Material Database Analysis

Author

Joel Sam

Introduction

This notebook is designed to perform the following functions:

  • Import MaterialTestData_{######}.xlsx
  • Analyze the count of tensile specimens for each material.

Tensile Database Overview

Tensile Specimen Overview

Material Pie Chart

Figure 1: Pie Chart of Tensile Specimen Count

Figure 2: Count Plot of tensile specimens, coded by Material

Figure 3: Count Plot of tensile specimens, coded by Orientation

Figure 4: Count Plot of tensile specimens, coded by Condition

Figure 5: Count Plot of tensile specimens, coded by Platform

Tensile Data

The following tensile specimens are excluded from the “Standard” dataset:

  • specimens with Orientations other than XY or Z
  • specimens with Test Temperatures above room temperature
  • specimens with Failure Codes
  • specimens with unknown Material

Figure 6: Standard tensile data

Figure 7: Standard tensile data, with Metric selection dropdown

Figure 8: Standard tensile data, with Material selection dropdown

Figure 9: Standard tensile data, with Material selection dropdown, split by Orientation and Condition

Single-Material Tensile Data

Nickel Alloy 718

Figure 10: NA718 Tensile Data, by Condition

Figure 11: NA718 Tensile Data, by Platform